package com.zh.tea.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class TeaExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TeaExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andTeanoIsNull() {
            addCriterion("teano is null");
            return (Criteria) this;
        }

        public Criteria andTeanoIsNotNull() {
            addCriterion("teano is not null");
            return (Criteria) this;
        }

        public Criteria andTeanoEqualTo(String value) {
            addCriterion("teano =", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoNotEqualTo(String value) {
            addCriterion("teano <>", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoGreaterThan(String value) {
            addCriterion("teano >", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoGreaterThanOrEqualTo(String value) {
            addCriterion("teano >=", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoLessThan(String value) {
            addCriterion("teano <", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoLessThanOrEqualTo(String value) {
            addCriterion("teano <=", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoLike(String value) {
            addCriterion("teano like", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoNotLike(String value) {
            addCriterion("teano not like", value, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoIn(List<String> values) {
            addCriterion("teano in", values, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoNotIn(List<String> values) {
            addCriterion("teano not in", values, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoBetween(String value1, String value2) {
            addCriterion("teano between", value1, value2, "teano");
            return (Criteria) this;
        }

        public Criteria andTeanoNotBetween(String value1, String value2) {
            addCriterion("teano not between", value1, value2, "teano");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(Double value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(Double value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(Double value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(Double value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(Double value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<Double> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<Double> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(Double value1, Double value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(Double value1, Double value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andStockIsNull() {
            addCriterion("stock is null");
            return (Criteria) this;
        }

        public Criteria andStockIsNotNull() {
            addCriterion("stock is not null");
            return (Criteria) this;
        }

        public Criteria andStockEqualTo(Integer value) {
            addCriterion("stock =", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockNotEqualTo(Integer value) {
            addCriterion("stock <>", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockGreaterThan(Integer value) {
            addCriterion("stock >", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockGreaterThanOrEqualTo(Integer value) {
            addCriterion("stock >=", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockLessThan(Integer value) {
            addCriterion("stock <", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockLessThanOrEqualTo(Integer value) {
            addCriterion("stock <=", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockIn(List<Integer> values) {
            addCriterion("stock in", values, "stock");
            return (Criteria) this;
        }

        public Criteria andStockNotIn(List<Integer> values) {
            addCriterion("stock not in", values, "stock");
            return (Criteria) this;
        }

        public Criteria andStockBetween(Integer value1, Integer value2) {
            addCriterion("stock between", value1, value2, "stock");
            return (Criteria) this;
        }

        public Criteria andStockNotBetween(Integer value1, Integer value2) {
            addCriterion("stock not between", value1, value2, "stock");
            return (Criteria) this;
        }

        public Criteria andShortinfoIsNull() {
            addCriterion("shortinfo is null");
            return (Criteria) this;
        }

        public Criteria andShortinfoIsNotNull() {
            addCriterion("shortinfo is not null");
            return (Criteria) this;
        }

        public Criteria andShortinfoEqualTo(String value) {
            addCriterion("shortinfo =", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoNotEqualTo(String value) {
            addCriterion("shortinfo <>", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoGreaterThan(String value) {
            addCriterion("shortinfo >", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoGreaterThanOrEqualTo(String value) {
            addCriterion("shortinfo >=", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoLessThan(String value) {
            addCriterion("shortinfo <", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoLessThanOrEqualTo(String value) {
            addCriterion("shortinfo <=", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoLike(String value) {
            addCriterion("shortinfo like", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoNotLike(String value) {
            addCriterion("shortinfo not like", value, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoIn(List<String> values) {
            addCriterion("shortinfo in", values, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoNotIn(List<String> values) {
            addCriterion("shortinfo not in", values, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoBetween(String value1, String value2) {
            addCriterion("shortinfo between", value1, value2, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andShortinfoNotBetween(String value1, String value2) {
            addCriterion("shortinfo not between", value1, value2, "shortinfo");
            return (Criteria) this;
        }

        public Criteria andSpecIsNull() {
            addCriterion("spec is null");
            return (Criteria) this;
        }

        public Criteria andSpecIsNotNull() {
            addCriterion("spec is not null");
            return (Criteria) this;
        }

        public Criteria andSpecEqualTo(String value) {
            addCriterion("spec =", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotEqualTo(String value) {
            addCriterion("spec <>", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecGreaterThan(String value) {
            addCriterion("spec >", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecGreaterThanOrEqualTo(String value) {
            addCriterion("spec >=", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLessThan(String value) {
            addCriterion("spec <", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLessThanOrEqualTo(String value) {
            addCriterion("spec <=", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLike(String value) {
            addCriterion("spec like", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotLike(String value) {
            addCriterion("spec not like", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecIn(List<String> values) {
            addCriterion("spec in", values, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotIn(List<String> values) {
            addCriterion("spec not in", values, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecBetween(String value1, String value2) {
            addCriterion("spec between", value1, value2, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotBetween(String value1, String value2) {
            addCriterion("spec not between", value1, value2, "spec");
            return (Criteria) this;
        }

        public Criteria andPackspecIsNull() {
            addCriterion("packspec is null");
            return (Criteria) this;
        }

        public Criteria andPackspecIsNotNull() {
            addCriterion("packspec is not null");
            return (Criteria) this;
        }

        public Criteria andPackspecEqualTo(String value) {
            addCriterion("packspec =", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecNotEqualTo(String value) {
            addCriterion("packspec <>", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecGreaterThan(String value) {
            addCriterion("packspec >", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecGreaterThanOrEqualTo(String value) {
            addCriterion("packspec >=", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecLessThan(String value) {
            addCriterion("packspec <", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecLessThanOrEqualTo(String value) {
            addCriterion("packspec <=", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecLike(String value) {
            addCriterion("packspec like", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecNotLike(String value) {
            addCriterion("packspec not like", value, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecIn(List<String> values) {
            addCriterion("packspec in", values, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecNotIn(List<String> values) {
            addCriterion("packspec not in", values, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecBetween(String value1, String value2) {
            addCriterion("packspec between", value1, value2, "packspec");
            return (Criteria) this;
        }

        public Criteria andPackspecNotBetween(String value1, String value2) {
            addCriterion("packspec not between", value1, value2, "packspec");
            return (Criteria) this;
        }

        public Criteria andLicensenoIsNull() {
            addCriterion("licenseno is null");
            return (Criteria) this;
        }

        public Criteria andLicensenoIsNotNull() {
            addCriterion("licenseno is not null");
            return (Criteria) this;
        }

        public Criteria andLicensenoEqualTo(String value) {
            addCriterion("licenseno =", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotEqualTo(String value) {
            addCriterion("licenseno <>", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoGreaterThan(String value) {
            addCriterion("licenseno >", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoGreaterThanOrEqualTo(String value) {
            addCriterion("licenseno >=", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoLessThan(String value) {
            addCriterion("licenseno <", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoLessThanOrEqualTo(String value) {
            addCriterion("licenseno <=", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoLike(String value) {
            addCriterion("licenseno like", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotLike(String value) {
            addCriterion("licenseno not like", value, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoIn(List<String> values) {
            addCriterion("licenseno in", values, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotIn(List<String> values) {
            addCriterion("licenseno not in", values, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoBetween(String value1, String value2) {
            addCriterion("licenseno between", value1, value2, "licenseno");
            return (Criteria) this;
        }

        public Criteria andLicensenoNotBetween(String value1, String value2) {
            addCriterion("licenseno not between", value1, value2, "licenseno");
            return (Criteria) this;
        }

        public Criteria andSeasonIsNull() {
            addCriterion("season is null");
            return (Criteria) this;
        }

        public Criteria andSeasonIsNotNull() {
            addCriterion("season is not null");
            return (Criteria) this;
        }

        public Criteria andSeasonEqualTo(String value) {
            addCriterion("season =", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonNotEqualTo(String value) {
            addCriterion("season <>", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonGreaterThan(String value) {
            addCriterion("season >", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonGreaterThanOrEqualTo(String value) {
            addCriterion("season >=", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonLessThan(String value) {
            addCriterion("season <", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonLessThanOrEqualTo(String value) {
            addCriterion("season <=", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonLike(String value) {
            addCriterion("season like", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonNotLike(String value) {
            addCriterion("season not like", value, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonIn(List<String> values) {
            addCriterion("season in", values, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonNotIn(List<String> values) {
            addCriterion("season not in", values, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonBetween(String value1, String value2) {
            addCriterion("season between", value1, value2, "season");
            return (Criteria) this;
        }

        public Criteria andSeasonNotBetween(String value1, String value2) {
            addCriterion("season not between", value1, value2, "season");
            return (Criteria) this;
        }

        public Criteria andTechIsNull() {
            addCriterion("tech is null");
            return (Criteria) this;
        }

        public Criteria andTechIsNotNull() {
            addCriterion("tech is not null");
            return (Criteria) this;
        }

        public Criteria andTechEqualTo(String value) {
            addCriterion("tech =", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechNotEqualTo(String value) {
            addCriterion("tech <>", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechGreaterThan(String value) {
            addCriterion("tech >", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechGreaterThanOrEqualTo(String value) {
            addCriterion("tech >=", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechLessThan(String value) {
            addCriterion("tech <", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechLessThanOrEqualTo(String value) {
            addCriterion("tech <=", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechLike(String value) {
            addCriterion("tech like", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechNotLike(String value) {
            addCriterion("tech not like", value, "tech");
            return (Criteria) this;
        }

        public Criteria andTechIn(List<String> values) {
            addCriterion("tech in", values, "tech");
            return (Criteria) this;
        }

        public Criteria andTechNotIn(List<String> values) {
            addCriterion("tech not in", values, "tech");
            return (Criteria) this;
        }

        public Criteria andTechBetween(String value1, String value2) {
            addCriterion("tech between", value1, value2, "tech");
            return (Criteria) this;
        }

        public Criteria andTechNotBetween(String value1, String value2) {
            addCriterion("tech not between", value1, value2, "tech");
            return (Criteria) this;
        }

        public Criteria andProlocIsNull() {
            addCriterion("proloc is null");
            return (Criteria) this;
        }

        public Criteria andProlocIsNotNull() {
            addCriterion("proloc is not null");
            return (Criteria) this;
        }

        public Criteria andProlocEqualTo(String value) {
            addCriterion("proloc =", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocNotEqualTo(String value) {
            addCriterion("proloc <>", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocGreaterThan(String value) {
            addCriterion("proloc >", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocGreaterThanOrEqualTo(String value) {
            addCriterion("proloc >=", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocLessThan(String value) {
            addCriterion("proloc <", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocLessThanOrEqualTo(String value) {
            addCriterion("proloc <=", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocLike(String value) {
            addCriterion("proloc like", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocNotLike(String value) {
            addCriterion("proloc not like", value, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocIn(List<String> values) {
            addCriterion("proloc in", values, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocNotIn(List<String> values) {
            addCriterion("proloc not in", values, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocBetween(String value1, String value2) {
            addCriterion("proloc between", value1, value2, "proloc");
            return (Criteria) this;
        }

        public Criteria andProlocNotBetween(String value1, String value2) {
            addCriterion("proloc not between", value1, value2, "proloc");
            return (Criteria) this;
        }

        public Criteria andProducedateIsNull() {
            addCriterion("producedate is null");
            return (Criteria) this;
        }

        public Criteria andProducedateIsNotNull() {
            addCriterion("producedate is not null");
            return (Criteria) this;
        }

        public Criteria andProducedateEqualTo(Date value) {
            addCriterionForJDBCDate("producedate =", value, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateNotEqualTo(Date value) {
            addCriterionForJDBCDate("producedate <>", value, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateGreaterThan(Date value) {
            addCriterionForJDBCDate("producedate >", value, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("producedate >=", value, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateLessThan(Date value) {
            addCriterionForJDBCDate("producedate <", value, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("producedate <=", value, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateIn(List<Date> values) {
            addCriterionForJDBCDate("producedate in", values, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateNotIn(List<Date> values) {
            addCriterionForJDBCDate("producedate not in", values, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("producedate between", value1, value2, "producedate");
            return (Criteria) this;
        }

        public Criteria andProducedateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("producedate not between", value1, value2, "producedate");
            return (Criteria) this;
        }

        public Criteria andBzqIsNull() {
            addCriterion("bzq is null");
            return (Criteria) this;
        }

        public Criteria andBzqIsNotNull() {
            addCriterion("bzq is not null");
            return (Criteria) this;
        }

        public Criteria andBzqEqualTo(Integer value) {
            addCriterion("bzq =", value, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqNotEqualTo(Integer value) {
            addCriterion("bzq <>", value, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqGreaterThan(Integer value) {
            addCriterion("bzq >", value, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqGreaterThanOrEqualTo(Integer value) {
            addCriterion("bzq >=", value, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqLessThan(Integer value) {
            addCriterion("bzq <", value, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqLessThanOrEqualTo(Integer value) {
            addCriterion("bzq <=", value, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqIn(List<Integer> values) {
            addCriterion("bzq in", values, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqNotIn(List<Integer> values) {
            addCriterion("bzq not in", values, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqBetween(Integer value1, Integer value2) {
            addCriterion("bzq between", value1, value2, "bzq");
            return (Criteria) this;
        }

        public Criteria andBzqNotBetween(Integer value1, Integer value2) {
            addCriterion("bzq not between", value1, value2, "bzq");
            return (Criteria) this;
        }

        public Criteria andTypeidIsNull() {
            addCriterion("typeid is null");
            return (Criteria) this;
        }

        public Criteria andTypeidIsNotNull() {
            addCriterion("typeid is not null");
            return (Criteria) this;
        }

        public Criteria andTypeidEqualTo(Integer value) {
            addCriterion("typeid =", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidNotEqualTo(Integer value) {
            addCriterion("typeid <>", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidGreaterThan(Integer value) {
            addCriterion("typeid >", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("typeid >=", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidLessThan(Integer value) {
            addCriterion("typeid <", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidLessThanOrEqualTo(Integer value) {
            addCriterion("typeid <=", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidIn(List<Integer> values) {
            addCriterion("typeid in", values, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidNotIn(List<Integer> values) {
            addCriterion("typeid not in", values, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidBetween(Integer value1, Integer value2) {
            addCriterion("typeid between", value1, value2, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("typeid not between", value1, value2, "typeid");
            return (Criteria) this;
        }

        public Criteria andBrandidIsNull() {
            addCriterion("brandid is null");
            return (Criteria) this;
        }

        public Criteria andBrandidIsNotNull() {
            addCriterion("brandid is not null");
            return (Criteria) this;
        }

        public Criteria andBrandidEqualTo(Integer value) {
            addCriterion("brandid =", value, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidNotEqualTo(Integer value) {
            addCriterion("brandid <>", value, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidGreaterThan(Integer value) {
            addCriterion("brandid >", value, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidGreaterThanOrEqualTo(Integer value) {
            addCriterion("brandid >=", value, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidLessThan(Integer value) {
            addCriterion("brandid <", value, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidLessThanOrEqualTo(Integer value) {
            addCriterion("brandid <=", value, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidIn(List<Integer> values) {
            addCriterion("brandid in", values, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidNotIn(List<Integer> values) {
            addCriterion("brandid not in", values, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidBetween(Integer value1, Integer value2) {
            addCriterion("brandid between", value1, value2, "brandid");
            return (Criteria) this;
        }

        public Criteria andBrandidNotBetween(Integer value1, Integer value2) {
            addCriterion("brandid not between", value1, value2, "brandid");
            return (Criteria) this;
        }

        public Criteria andPic1IsNull() {
            addCriterion("pic1 is null");
            return (Criteria) this;
        }

        public Criteria andPic1IsNotNull() {
            addCriterion("pic1 is not null");
            return (Criteria) this;
        }

        public Criteria andPic1EqualTo(String value) {
            addCriterion("pic1 =", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1NotEqualTo(String value) {
            addCriterion("pic1 <>", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1GreaterThan(String value) {
            addCriterion("pic1 >", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1GreaterThanOrEqualTo(String value) {
            addCriterion("pic1 >=", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1LessThan(String value) {
            addCriterion("pic1 <", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1LessThanOrEqualTo(String value) {
            addCriterion("pic1 <=", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1Like(String value) {
            addCriterion("pic1 like", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1NotLike(String value) {
            addCriterion("pic1 not like", value, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1In(List<String> values) {
            addCriterion("pic1 in", values, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1NotIn(List<String> values) {
            addCriterion("pic1 not in", values, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1Between(String value1, String value2) {
            addCriterion("pic1 between", value1, value2, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic1NotBetween(String value1, String value2) {
            addCriterion("pic1 not between", value1, value2, "pic1");
            return (Criteria) this;
        }

        public Criteria andPic2IsNull() {
            addCriterion("pic2 is null");
            return (Criteria) this;
        }

        public Criteria andPic2IsNotNull() {
            addCriterion("pic2 is not null");
            return (Criteria) this;
        }

        public Criteria andPic2EqualTo(String value) {
            addCriterion("pic2 =", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2NotEqualTo(String value) {
            addCriterion("pic2 <>", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2GreaterThan(String value) {
            addCriterion("pic2 >", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2GreaterThanOrEqualTo(String value) {
            addCriterion("pic2 >=", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2LessThan(String value) {
            addCriterion("pic2 <", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2LessThanOrEqualTo(String value) {
            addCriterion("pic2 <=", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2Like(String value) {
            addCriterion("pic2 like", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2NotLike(String value) {
            addCriterion("pic2 not like", value, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2In(List<String> values) {
            addCriterion("pic2 in", values, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2NotIn(List<String> values) {
            addCriterion("pic2 not in", values, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2Between(String value1, String value2) {
            addCriterion("pic2 between", value1, value2, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic2NotBetween(String value1, String value2) {
            addCriterion("pic2 not between", value1, value2, "pic2");
            return (Criteria) this;
        }

        public Criteria andPic3IsNull() {
            addCriterion("pic3 is null");
            return (Criteria) this;
        }

        public Criteria andPic3IsNotNull() {
            addCriterion("pic3 is not null");
            return (Criteria) this;
        }

        public Criteria andPic3EqualTo(String value) {
            addCriterion("pic3 =", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3NotEqualTo(String value) {
            addCriterion("pic3 <>", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3GreaterThan(String value) {
            addCriterion("pic3 >", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3GreaterThanOrEqualTo(String value) {
            addCriterion("pic3 >=", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3LessThan(String value) {
            addCriterion("pic3 <", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3LessThanOrEqualTo(String value) {
            addCriterion("pic3 <=", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3Like(String value) {
            addCriterion("pic3 like", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3NotLike(String value) {
            addCriterion("pic3 not like", value, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3In(List<String> values) {
            addCriterion("pic3 in", values, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3NotIn(List<String> values) {
            addCriterion("pic3 not in", values, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3Between(String value1, String value2) {
            addCriterion("pic3 between", value1, value2, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic3NotBetween(String value1, String value2) {
            addCriterion("pic3 not between", value1, value2, "pic3");
            return (Criteria) this;
        }

        public Criteria andPic4IsNull() {
            addCriterion("pic4 is null");
            return (Criteria) this;
        }

        public Criteria andPic4IsNotNull() {
            addCriterion("pic4 is not null");
            return (Criteria) this;
        }

        public Criteria andPic4EqualTo(String value) {
            addCriterion("pic4 =", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4NotEqualTo(String value) {
            addCriterion("pic4 <>", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4GreaterThan(String value) {
            addCriterion("pic4 >", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4GreaterThanOrEqualTo(String value) {
            addCriterion("pic4 >=", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4LessThan(String value) {
            addCriterion("pic4 <", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4LessThanOrEqualTo(String value) {
            addCriterion("pic4 <=", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4Like(String value) {
            addCriterion("pic4 like", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4NotLike(String value) {
            addCriterion("pic4 not like", value, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4In(List<String> values) {
            addCriterion("pic4 in", values, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4NotIn(List<String> values) {
            addCriterion("pic4 not in", values, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4Between(String value1, String value2) {
            addCriterion("pic4 between", value1, value2, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic4NotBetween(String value1, String value2) {
            addCriterion("pic4 not between", value1, value2, "pic4");
            return (Criteria) this;
        }

        public Criteria andPic5IsNull() {
            addCriterion("pic5 is null");
            return (Criteria) this;
        }

        public Criteria andPic5IsNotNull() {
            addCriterion("pic5 is not null");
            return (Criteria) this;
        }

        public Criteria andPic5EqualTo(String value) {
            addCriterion("pic5 =", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5NotEqualTo(String value) {
            addCriterion("pic5 <>", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5GreaterThan(String value) {
            addCriterion("pic5 >", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5GreaterThanOrEqualTo(String value) {
            addCriterion("pic5 >=", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5LessThan(String value) {
            addCriterion("pic5 <", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5LessThanOrEqualTo(String value) {
            addCriterion("pic5 <=", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5Like(String value) {
            addCriterion("pic5 like", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5NotLike(String value) {
            addCriterion("pic5 not like", value, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5In(List<String> values) {
            addCriterion("pic5 in", values, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5NotIn(List<String> values) {
            addCriterion("pic5 not in", values, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5Between(String value1, String value2) {
            addCriterion("pic5 between", value1, value2, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic5NotBetween(String value1, String value2) {
            addCriterion("pic5 not between", value1, value2, "pic5");
            return (Criteria) this;
        }

        public Criteria andPic6IsNull() {
            addCriterion("pic6 is null");
            return (Criteria) this;
        }

        public Criteria andPic6IsNotNull() {
            addCriterion("pic6 is not null");
            return (Criteria) this;
        }

        public Criteria andPic6EqualTo(String value) {
            addCriterion("pic6 =", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6NotEqualTo(String value) {
            addCriterion("pic6 <>", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6GreaterThan(String value) {
            addCriterion("pic6 >", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6GreaterThanOrEqualTo(String value) {
            addCriterion("pic6 >=", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6LessThan(String value) {
            addCriterion("pic6 <", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6LessThanOrEqualTo(String value) {
            addCriterion("pic6 <=", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6Like(String value) {
            addCriterion("pic6 like", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6NotLike(String value) {
            addCriterion("pic6 not like", value, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6In(List<String> values) {
            addCriterion("pic6 in", values, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6NotIn(List<String> values) {
            addCriterion("pic6 not in", values, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6Between(String value1, String value2) {
            addCriterion("pic6 between", value1, value2, "pic6");
            return (Criteria) this;
        }

        public Criteria andPic6NotBetween(String value1, String value2) {
            addCriterion("pic6 not between", value1, value2, "pic6");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}